www.gusucode.com > 婚庆仪礼策划公司网站系统源代码 梦紫色 > 婚庆仪礼策划公司网站系统源代码 梦紫色/Admin/admin_p.asp

    <!--#include file="conn.asp"-->
<!--#include file="inc/format.asp"-->
<!--#include file="inc/error.asp"-->
<!--#include file="check1.asp"-->
<!--#include file="inc/p_body.asp"-->

<title>错误提示</title>
<%
dim founderr,errmsg
founderr=false
errmsg=""

if Request.form("MM_insert") then

if request.form("action")="newp" then
sql="select * from p_class"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
rs.addnew
dim p_type
p_type=trim(replace(request.form("p_type"),"'",""))
p_type_e=request.form("p_type_e")
if p_type="" then
  founderr=true
  errmsg=errmsg+"<br>"+"<li>你必须输入栏目名称名称！"
else
  rs("p_type")=p_type
End if

paixu=request("paixu")
if paixu="" then
  founderr=true
  errmsg=errmsg+"<br>"+"<li>你必须输入排序顺序！"
else
  rs("orders")=paixu
End if

rs("p_type_e")=p_type_e
if Not founderr then
rs.update
rs.close
set rs=Nothing
  closedatabase
response.redirect "admin_p.asp"
else
Call diserror()
response.End
End if
End if

if request.form("action")="editp" then
if request.Form("id")="" then
  founderr=true
  errmsg=errmsg+"<br>"+"<li>你必须指定操作的对象！"
else
  if Not isInteger(request.form("id")) then
    founderr=true
    errmsg=errmsg+"<br>"+"<li>非法的id参数。"
  End if
End if
if founderr then
  Call diserror()
  response.End
End if
sql="select * from p_class where p_id="&cint(request.Form("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
p_old_type=rs("p_type")
p_old_type_e=rs("p_type_e")
'dim p_type
p_type=trim(replace(request.form("p_type"),"'",""))
p_type_e=request.form("p_type_e")
if p_type="" then
  founderr=true
  errmsg=errmsg+"<br>"+"<li>你必须输入栏目名称！"
else
  rs("p_type")=p_type
End if

paixu=request("paixu")
if paixu="" then
  founderr=true
  errmsg=errmsg+"<br>"+"<li>你必须输入排序顺序！"
else
  rs("orders")=paixu
End if

rs("p_type_e")=p_type_e

if Not founderr then
rs.update
rs.close
set rs=Nothing
'连代更新二级分类
v_sql="select * from p_class_small where p_type='"&p_old_type&"'"
response.write v_sql
set v_rs=server.createobject("adodb.recordset")
v_rs.open v_sql,conn,1,3
if Not(v_rs.BOF or v_rs.EOF) then
do while not v_rs.eof
v_rs("p_type")=p_type
v_rs("p_type_e")=p_type_e
v_rs.update
v_rs.movenext
loop
End if
v_rs.close
set v_rs=Nothing
'连代更新属于此大类的信息
v_sql="select * from p_info where p_type='"&p_old_type&"'"
set v_rs=server.createobject("adodb.recordset")
v_rs.open v_sql,conn,1,3
if Not(v_rs.BOF or v_rs.EOF) then
do while not v_rs.eof
v_rs("p_type")=p_type
v_rs("p_type_e")=p_type_e
v_rs.update
v_rs.movenext
loop
End if
v_rs.close
set v_rs=Nothing
response.redirect "admin_p.asp"
else
Call diserror()
response.End
End if
End if

if request.form("action")="delp" then
if request.Form("id")="" then
  founderr=true
  errmsg=errmsg+"<br>"+"<li>你必须指定操作的对象！"
else
  if Not isInteger(request.form("id")) then
    founderr=true
    errmsg=errmsg+"<br>"+"<li>非法的id参数。"
  End if
End if
if founderr then
  Call diserror()
  response.End
End if
sql="select * from p_class where p_id="&cint(request.Form("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
if Not(rs.BOF or rs.EOF) then
rs.delete
End if
rs.close
set rs=Nothing

'连代删除二级分类
v_sql="select * from p_class_small where p_type='"&p_type&"'"
set v_rs=server.createobject("adodb.recordset")
v_rs.open v_sql,conn,1,3
if Not(v_rs.BOF or v_rs.EOF) then
do while not v_rs.eof
v_rs.delete
v_rs.movenext
loop
End if
v_rs.close
set v_rs=Nothing
'连代删除属于此大类的信息
v_sql="select * from p_info where p_type='"&p_type&"'"
set v_rs=server.createobject("adodb.recordset")
v_rs.open v_sql,conn,1,3
if Not(v_rs.BOF or v_rs.EOF) then
do while not v_rs.eof
v_rs.delete
v_rs.movenext
loop
End if
v_rs.close
set v_rs=Nothing
closedatabase
response.redirect "admin_p.asp"
End if
End if

Call p_body()
closedatabase
%>